package com.smartwebx.ha.dal.realtime.dao;

import java.util.List;

import org.apache.ibatis.annotations.CacheNamespace;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.smartwebx.ha.dal.config.OracleConfigInfo;
import com.smartwebx.ha.dal.usebean.RsvrfsrBean;

/**
 * 讯线水位
 * 
 * @author zhangxi
 * 
 */
@CacheNamespace(size = 512, readWrite = false)
public interface RsvrfsrMapper {
	String ST_RSVRFSR_B = OracleConfigInfo.REALTIME_NAME + ".ST_RSVRFSR_B";

	@Select("SELECT * FROM " + ST_RSVRFSR_B + " WHERE STCD=#{stcd} AND (BGMD<=1231 or EDMD<=1231)")
	public List<RsvrfsrBean> getRsvrfsrByStcd(@Param("stcd") String stcd);

	@Select("SELECT * FROM " + ST_RSVRFSR_B + " WHERE BGMD<=1231 or EDMD<=1231")
	public List<RsvrfsrBean> getAllRsvrfsr();
}